﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="NetSheetPrint.aspx.cs"
    Inherits="LenderClearingHouse.NetSheetPrint" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .td_number
        {
            text-align:right;
        }
        .style1
        {
        }
        .style2
        {
        }
        .style3
        {
        }
        .style4
        {
        }
        .style5
        {
        }
    </style>
    <script type="text/javascript">
        
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div style="width:750px">
    <table style="width: 100%; font-family: Arial, Helvetica, sans-serif; font-size: 10px;">
        <tr>
          <td colspan="3" style="background-color: #C0C0C0; font-weight: bold; text-align: center;">
            Lender’s Clearing House Las Vegas
          </td>
        </tr>
        <tr>
          <td style="width:245">
            <table style="width:100%">
              <tr>
                <td align="right" style="font-weight: bold; width: 80px;">
                    Property&nbsp;Address: 
                </td>
                <td runat="server" id="edPropertyLocation">
                </td>
              </tr>
              <tr>
                <td align="right">
                    Buyer's&nbsp;Name:
                </td>
                <td runat="server" id="edInvestorName">
                </td>
              </tr>
              <tr>
                <td align="right">
                    Selling&nbsp;Price:
                </td>
                <td runat="server" id="tbSellingPrice">
                </td>
              </tr>
              <tr>
                <td align="right">
                    Mortgage&nbsp;Type:
                </td>
                <td runat="server" id="cbMortgageType">
                </td>
              </tr>
              <tr>
                <td align="right">
                    Down&nbsp;Payment:
                </td>
                <td runat="server" id="tbDownPayment">
                </td>
              </tr>
              <tr>
                <td align="right">
                    Est&nbsp;closing&nbsp;date:
                </td>
                <td runat="server" id="tbEstClosingDate">
                </td>
              </tr>
            </table>
          </td>
          <td style="width:5px"></td>
          <td style="width:500px; vertical-align:top;">
            <table style="width:100%;">
              <tr>
                <td style="width:30px">
                    #&nbsp;Bedrooms/Baths
                </td>
                <td style="width:220px" runat="server" id="edBedrooms">
                </td>
                <td style="width:30px">
                  Occupancy
                </td>
                <td style="width:220px" runat="server" id="ddlOccupancy">
                </td>
               </tr>
              <tr>
                <td>
                    Year&nbsp;Built
                </td>
                <td runat="server" id="edConstructYear">
                </td>
                <td colspan="2"></td>
              </tr>
              <tr>
                <td>
                  Square&nbsp;feet
                </td>
                <td runat="server" id="edTotalSqft">
                </td>
                <td colspan="2"></td>
              </tr>
              <tr>
                <td>
                  Acquisition&nbsp;Date:                
                </td>
                <td runat="server" id="tbAcquisitionDate">
                </td>
                <td colspan="2"></td>
              </tr>
              <tr>
                <td>
                  Garage
                </td>
                <td runat="server" id="edGarageSqft">
                </td>
                <td colspan="2"></td>
              </tr>
              <tr>
                <td>
                  Pool
                 </td>
                 <td runat="server" id="edPool">
                 </td>
                 <td colspan="2"></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <br />
              
        <table style="width: 100%; font-family: Arial, Helvetica, sans-serif; font-size: 10px;">
          <tr>
            <td colspan="7" style="font-weight: bold; background-color: #C0C0C0; text-align: center;">
              NET SHEET
            </td>
          </tr>
          <tr>
            <td width="150px" align="center">
              Purchase Detail
            </td>
            <td width="30px" align="center">
              %
            </td>
            <td width="50px" style="font-weight: bold;" align="center">
              Estimated
            </td>
            <td width="50px" style="font-weight: bold;" align="center">
              Actual
            </td>
            <td width="50px" style="font-weight: bold;" align="center">
              With Loan
            </td>
          </tr>
          <tr>
            <td style="background-color: #C0C0C0">
              <strong>ACQUISITION COST</strong>
            </td>
            <td colspan="6"></td>
          </tr>
          <tr>
          <td>
            Purchase Price
          </td>
          <td>
            &nbsp;
          </td>
          <td runat="server" id="tbPurchasePriceEstimated" class="td_number">
          </td>
          <td runat="server" id="tbPurchasePriceActual" class="td_number">
          </td>
          <td runat="server" id="tbPurchasePriceLoan" class="td_number">
           </td>
           <td colspan="2">
            &nbsp;
           </td>
         </tr>
          <tr>
            <td class="style2">
              Non- Profit Fee
            </td>
            <td runat="server" id="tbNonProfitFeePercent" class="td_number">
            </td>
            <td runat="server" id="tbNonProfitFeeEstimated" class="td_number">
            </td>
            <td runat="server" id="tbNonProfitFeeActual" class="td_number">
            </td>
            <td runat="server" id="tbNonProfitFeeLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2">
              Closing Costs - Front End
            </td>
            <td runat="server" id="tbClosingCostsPercent" class="td_number">
            </td>
            <td runat="server" id="tbClosingCostsEstimated" class="td_number">
            </td>
            <td runat="server" id="tbClosingCostsActual" class="td_number">
            </td>
            <td runat="server" id="tbClosingCostsLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              TOTAL
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbAcquisitionEstimated" class="td_number">
            </td>
            <td runat="server" id="tbAcquisitionActual" class="td_number">
            </td>
            <td runat="server" id="tbAcquisitionLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td style="background-color: #C0C0C0">
              <strong>PREPARATION COST</strong>
            </td>
            <td colspan="6">&nbsp;</td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Rehab Cost
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbRehabCostEstimated" class="td_number">
            </td>
            <td runat="server" id="tbRehabCostActual" class="td_number">
            </td>
            <td runat="server" id="tbRehabCostLoan" class="td_number">
            </td>
            <td colspan="2" style="text-align:left;">
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Lock Change &amp; Secure Property
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbLockEstimated" class="td_number">
            </td>
            <td runat="server" id="tbLockActual" class="td_number">
            </td>
            <td runat="server" id="tbLockLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Reserve for Utilites
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbReserveEstimated" class="td_number">
            </td>
            <td runat="server" id="tbReserveActual" class="td_number">
            </td>
            <td runat="server" id="tbReserveLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Insurance
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbInsuranceEstimated" class="td_number">
            </td>
            <td runat="server" id="tbInsuranceActual" class="td_number">
            </td>
            <td runat="server" id="tbInsuranceLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Cash for Keys/ Eviction
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbCashEstimated" class="td_number">
            </td>
            <td runat="server" id="tbCashActual" class="td_number">
            </td>
            <td runat="server" id="tbCashLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Miscellaenous
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbMiscEstimated" class="td_number">
            </td>
            <td runat="server" id="tbMiscActual" class="td_number">
            </td>
            <td runat="server" id="tbMiscLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              TOTAL
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbPreparationEstimated" class="td_number">
            </td>
            <td runat="server" id="tbPreparationActual" class="td_number">
            </td>
            <td runat="server" id="tbPreparationLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>TOTAL PRE-SALE COSTS</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbTotalPresaleEstimated" class="td_number">
            </td>
            <td runat="server" id="tbTotalPresaleActual" class="td_number">
            </td>
            <td runat="server" id="tbTotalPresaleLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td style="background-color: #C0C0C0">
              <strong>CLOSING COST</strong>
            </td>
            <td colspan="6">&nbsp;</td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Selling Price
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbSellingPriceEstimated" class="td_number">
            </td>
            <td runat="server" id="tbSellingPriceActual" class="td_number">
            </td>
            <td runat="server" id="tbSellingPriceLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2">
              Broker Coop
            </td>
            <td runat="server" id="tbBrokerPercent" class="td_number">
            </td>
            <td runat="server" id="tbBrokerEstimated" class="td_number">
            </td>
            <td runat="server" id="tbBrokerActual" class="td_number">
            </td>
            <td runat="server" id="tbBrokerLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2">
              Seller Closing Incentives
            </td>
            <td runat="server" id="tbSellerPercent" class="td_number">
            </td>
            <td runat="server" id="tbSellerClosingEstimated" class="td_number">
            </td>
            <td runat="server" id="tbSellerClosingActual" class="td_number">
            </td>
            <td runat="server" id="tbSellerClosingLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2">
              Escrow Closing Estimate
            </td>
            <td runat="server" id="tbEscrowPercent" class="td_number">
            </td>
            <td runat="server" id="tbEscrowEstimated" class="td_number">
            </td>
            <td runat="server" id="tbEscrowActual" class="td_number">
            </td>
            <td runat="server" id="tbEscrowLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Sellers Cost of Repairs
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbSellersCostEstimated" class="td_number">
            </td>
            <td runat="server" id="tbSellersCostActual" class="td_number">
            </td>
            <td runat="server" id="tbSellersCostLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Home Warranty
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbHomeEstimated" class="td_number">
            </td>
            <td runat="server" id="tbHomeActual" class="td_number">
            </td>
            <td runat="server" id="tbHomeLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Appraisal
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbAppraisalEstimated" class="td_number">
            </td>
            <td runat="server" id="tbAppraisalActual" class="td_number">
            </td>
            <td runat="server" id="tbAppraisalLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Miscellaneous Closing Costs
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbMiscClosingEstimated" class="td_number">
            </td>
            <td runat="server" id="tbMiscClosingActual" class="td_number">
            </td>
            <td runat="server" id="tbMiscClosingLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              HOA Dues
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbHoaEstimated" class="td_number">
            </td>
            <td runat="server" id="tbHoaActual" class="td_number">
            </td>
            <td runat="server" id="tbHoaLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Transaction Fee
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbTransactionEstimated" class="td_number">
            </td>
            <td runat="server" id="tbTransactionActual" class="td_number">
            </td>
            <td runat="server" id="tbTransactionLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: left">
              Other
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbOtherEstimated" class="td_number">
            </td>
            <td runat="server" id="tbOtherActual" class="td_number">
            </td>
            <td runat="server" id="tbOtherLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>TOTAL CLOSING COSTS</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbTotalClosingCostsEstimated" class="td_number">
            </td>
            <td runat="server" id="tbTotalClosingCostsActual" class="td_number">
            </td>
            <td runat="server" id="tbTotalClosingCostsLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td style="background-color: #C0C0C0" colspan="4">
              <strong>LOAN COST</strong>
            </td>
            <td runat="server" id="tbPurchasePlusRehab" class="td_number">
            </td>
            <td colspan="2"><asp:Label ID="lblPurchasePlusRehab" runat="server" Text="Note (Purchase + Rehab)"></asp:Label></td>
          </tr>
          <tr>
            <td>
            </td>
            <td colspan="3">
              &nbsp;
            </td>
            <td runat="server" id="tb1stDOT" class="td_number">
            </td>
            <td colspan="2"><asp:Label ID="lbl1stDOT" runat="server" Text="1st DOT"></asp:Label></td>
          </tr>
          <tbody runat="server" id="tbodyLoan">
          <tr>
            <td colspan="4">
              &nbsp;
            </td>
            <td runat="server" id="tb2ndDOT" class="td_number">
            </td>
            <td colspan="2">2nd DOT</td>
          </tr>
          <tr>
            <td colspan="4">
              &nbsp;
            </td>
            <td runat="server" id="tbLoanBrokerFee" class="td_number">
            </td>
            <td colspan="2">Loan Broker Fee</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td runat="server" id="tbLoanFeePercent" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
            <td runat="server" id="tbLoanFeeCalculated" class="td_number">
            </td>
            <td colspan="2">Loan Fee</td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td runat="server" id="tbLoanInterestPercent" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
            <td runat="server" id="tbLoanInterestCalculated" class="td_number">
            </td>
            <td colspan="2">Loan Interest (2mo)</td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>TOTAL LOAN COST</strong>
            </td>
            <td colspan="3">
              &nbsp;
            </td>
            <td runat="server" id="tbLoanTotal" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          </tbody>

          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>NET PROFIT</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbNetProfitEstimated" class="td_number">
            </td>
            <td runat="server" id="tbNetProfitActual" class="td_number">
            </td>
            <td runat="server" id="tbNetProfitLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>Fee to LCH Las Vegas</strong>
            </td>
            <td runat="server" id="tbProfitParticipationPercent" class="td_number">
            </td>
            <td runat="server" id="tbProfitParticipationEstimated" class="td_number">
            </td>
            <td runat="server" id="tbProfitParticipationActual" class="td_number">
            </td>
            <td runat="server" id="tbProfitParticipationLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>TOTAL EQUITY</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbEquityEstimated" class="td_number">
            </td>
            <td runat="server" id="tbEquityActual" class="td_number">
            </td>
            <td runat="server" id="tbEquityLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>TOTAL NET NET PROFIT</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbTotalNetProfitEstimated" class="td_number">
            </td>
            <td runat="server" id="tbTotalNetProfitActual" class="td_number">
            </td>
            <td runat="server" id="tbTotalNetProfitLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td class="style2" style="text-align: right">
              <strong>Cash on cash return %</strong>
            </td>
            <td class="style3">
              &nbsp;
            </td>
            <td runat="server" id="tbTotalNetPercentEstimated" class="td_number">
            </td>
            <td runat="server" id="tbTotalNetPercentActual" class="td_number">
            </td>
            <td runat="server" id="tbTotalNetPercentLoan" class="td_number">
            </td>
            <td colspan="2">
              &nbsp;
            </td>
          </tr>
          <tr>
            <td colspan="7">
              &nbsp;
            </td>
          </tr>
        </table>
    </div>
    </form>
</body>
</html>
